package com.dbms.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dbms.domain.entity.BisXajmodeParas;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface BisXajmodeParasMapper extends BaseMapper<BisXajmodeParas> {
    int deleteByPrimaryKey(String id);

    int insert(BisXajmodeParas record);

    int insertSelective(BisXajmodeParas record);

    BisXajmodeParas selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(BisXajmodeParas record);

    int updateByPrimaryKey(BisXajmodeParas record);

    @Select("SELECT id, rcode, rnname, stname, stcd, zsfxxs_m, zsfxxs_s, zsfxxs, " +
            "zysrl_m, zysrl_s, zysrl, ugo_m, ugo_s, ugo, ogf_m, ogf_s, ogf, " +
            "rcfs_m, rcfs_s, rcfs, rcfr_m, rcfr_s, rcfr, ctw_m, ctw_s, ctw, " +
            "uctw_m, uctw_s, uctw, cltw_m, cltw_s, cltw, dec_m, dec_s, `dec`, dcsc_m, dcsc_s, dcsc, fcdc_m, fcdc_s, fcdc, pia_m, pia_s, pia\n" +
            "FROM bis_xajmode_paras\n" +
            "WHERE stcd=#{stationCode}")
    BisXajmodeParas queryInfo(@Param("stationCode") String stationCode);

    @Select("SELECT id, rcode, rnname, stname, stcd, zsfxxs_m, zsfxxs_s, zsfxxs, " +
            "zysrl_m, zysrl_s, zysrl, ugo_m, ugo_s, ugo, ogf_m, ogf_s, ogf, " +
            "rcfs_m, rcfs_s, rcfs, rcfr_m, rcfr_s, rcfr, ctw_m, ctw_s, ctw, " +
            "uctw_m, uctw_s, uctw, cltw_m, cltw_s, cltw, dec_m, dec_s, `dec`, dcsc_m, dcsc_s, dcsc, fcdc_m, fcdc_s, fcdc, pia_m, pia_s, pia\n" +
            "FROM bis_xajmode_paras\n" +
            "WHERE id=#{id}")
    BisXajmodeParas queryInfoById(@Param("id") String id);
}